package com.woniuxy.classdeans.mapper;

import com.woniuxy.commons.entity.AnswerSheet;
import com.woniuxy.commons.entity.SchoolInfo;
import com.woniuxy.commons.entity.ScoreLine;
import com.woniuxy.commons.entity.StudentInfo;
import com.woniuxy.commons.entity.wyh.GradeInfo;
import com.woniuxy.commons.entity.wyh.Knowledgepoint;
import com.woniuxy.commons.entity.wyh.TeamInfo;

import java.util.List;
import java.util.Set;

public interface KonwledgeAnalyzeMapper {
    //查询全部的学校信息
    public List<SchoolInfo> schoolAll();
    //获取所有高三的学生届数
    List<GradeInfo> semesterAll(String gradeType);
    //通过科目名称查寻对应知识点
    List<Knowledgepoint> knowledgesAll(String subject);

    double findAnswerSheetByTimeAndGaids(AnswerSheet as);

    List<Integer> findGaidBytmId(Integer gaId);

    List<Integer> findStudentByClassIdAndSchoolId(StudentInfo studentInfo);

    Double findStudentIdByScore(Integer sheetStudentNo);

    StudentInfo findStudentIdByDate(StudentInfo studentInfo);

    TeamInfo selectByGaid(TeamInfo teamInfo);

    GradeInfo selectByBeginyear(GradeInfo gradeInfo);

    Integer findStudentExamination(Integer gradeInfo);

    List<ScoreLine> findScoreChart();

    Set<Integer> findSidStudentId(Integer sid);

    Double findSidStudentScore(Integer s);

    String findSchoolNameBySid(Integer sid);
}
